﻿
CREATE procedure [dbo].[FC_Forecast_Update]
@IdForecast INT,
@IdUsuario int, 
@IdCustomer int,
@IdPeriod int, 
@IdProduct int, 
@Volume int
as
BEGIN
	UPDATE [dbo].[FC_Forecast]
    SET [IdUsuario] = @IdUsuario
      ,[IdPeriod] = @IdPeriod 
      ,[IdCustomer] = @IdCustomer
      ,[IdProduct] = @IdProduct
      ,[Volume] = @Volume
      ,[DateMod] = GETDATE()
	WHERE IdForecast = @IdForecast
END